Please help very urgent ageing by if condiction
Try this:
=CHOOSE(DATEDIF(DATE(B2,A2,1),TODAY(),"m")+1,"curr ent","30","60","120")
--
Regards!
Stefi
€˛pol€¯ ezt Ć*rta:
I have three column in my excel sheet
1. Month
2. year
3. Amount
4. Period
In period column, I want to show
1. if the month is current month it should be shown as ' Curnet'
2. If the previous month it should be shown as '30'
3 if before previous month it should be 60
4 otherwise '120'
Please help
|