Random Dates

In Excel dates are stored as numbers.

To generate random dates you can use the RANDBETWEEN function with a start date and an end date.

random DateThe formula in cell C2 is


Cell C2 has been formatted as a date.

This formula is dynamic. Each time Excel calculates it will update and most likely change.

You can use Copy > Paste Values to capture the date(s).



Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.