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

=RANDBETWEEN(A2,B2)

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 *