Excel after header A and B write a formula

hello, i have make a excel file where my Column A anCreateFileEveryMonth.xaml (26.8 KB) d B there a formula how can i apply it
ITT1 collation 2021 -1.xlsx (1.0 MB)

A and B forumlua are
=TEXT(C1203,“MMM”) this is A
==WEEKNUM(C1203,2) this is B

@CoolRobot,

Take two write cell activities and provide formula into value property

=Text(C1203, ““MMM””)
Second one, write as it is, no change in it

2 Likes

so this also work like in
Text(C2, “MMM”)
WEEKNUM(C2,2) ??

@CoolRobot
write as below
=WEEKNUM(C1203,2)

Thanks you is working perfectly :slight_smile:

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.