| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the random date between the start date and the end
Agreed.
OP: If you still want to play this tack, change B1 to: =IF(AND(DAY(A1)<1,A1<DATE(YEAR(A1),MONTH(A1)+1,0 )),A1,"") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "daddylonglegs" wrote in message ... But that would skew the results, dates which are the 2nd or 3rd of the month would be more likely to appear....and you could also generate dates outside the range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minimum Date Greater Than Observation Start Date | Excel Discussion (Misc queries) | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
| how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
Hybrid Mode
