Pages

Search

Excel Help Forum - Excel Formulas & Functions: Converting a date serial number back to a date within a string

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Converting a date serial number back to a date within a string
Hi all, I'm working on something that will return the applicable dates given certain conditions. I have one condition that would return a date range. I am currently trying to use, as an example: =if(A3="Marriage", A3&" - "&A3+31-DATE(A3+31)+1) In theory, this would return 10/15/2012 -...